MIS 24053 F05 Steinberg_Bakes
Fall 2005: M&IS 24053: Computer Applications
> <br>
> <br>
|
Dr. Geoffrey Steinberg
> <a href="mailto:gsteinbe@bsa3.kent.edu"><u>gsteinbe@bsa3.kent.edu<u> > <b>College of Business A418; Office Hours |
Dr. Catherine Bakes
> <a href="mailto:cbakes@bsa3.kent.edu"><u>cbakes@bsa3.kent.edu<u> > <b>College<b> of Business A405; Office Hours: > <nobr>Tues & Thurs 3-5:15 pm and <b>6:45-7 pm<b> > Phone: (330) 672-1162 <b> |
|
Sections 002 & 003
> Tuesday & Thursday <b>9:15-10:30 AM > University Auditorium <br> > Section 003 also meets: <br> Tuesday 10:45-12:00 > BOW 313 <b> |
Section 001
> <nobr>Tuesday Thursday 5:30-6:45pm > 215 BSA <b> |
Syllabus Contents (click to print syllabus)
1. Course Theme
Solving information related problems using computers, networks, software and data.
> <br>
> <br>
2. Course Objectives
The fundamental objective is for you to develop an appreciation for the contribution that computers and software can make to your life as a student and as a professional. It is expected that during this term you will develop competency in the operation of the hardware and software to which you are exposed. It is further expected that as you master the course material your confidence in your ability will increase. A secondary objective is for this to be an enjoyable and fun learning experience.
> <br>
> <br>
3. Textbook and Other Materials
The course's text book is Information, Steinberg, Geoffrey, Paperclip Productions © Fall 2005
Most of the text's material will be covered. Use the course's weekly schedule as a guide so that you read the appropriate chapters before that material is covered in class. You should read the material before coming to class so that you are ready to participate in the class discussion.
Class Slide Presentations
Copies of the instructor's classroom slide presentations are included with the textbook. You will find these copies very handy when you take class notes. The textbook has exact images of many of the slides used by the instructor. Take your notes directly on the copies. It will make note taking easier and more accurate. You will find it easier to study for quizzes too.
Class Notes
The textbook provides pages for your class note taking. You are encouraged to use these pages so that your notes, the text material and the classroom slides are kept together. This too will help you master the material and prepare for quizzes.
Floppy Disk
You should use the floppy disk which is packaged with the book. Although not required, you may wish to purchase a 3.5" floppy disk to use for backing up your homework.
4. Orion
Many of your course activities are interactive and involve using the Orion server. Quizzes and homework are administered and graded by Orion.
Follow these steps to log on to Orion:
1. Start a web browser:
§ You must use Internet Explorer.
§ You must allow popup windows to log on.
2. Go to this web address: http://orion.kent.edu
3. Select this option:
> <br>
> <br>
4. Enter your log on information:
> <br>
> <br>
5. Homework
There are 12 regular assignments. To view specifics about assignments use your ID and password to log on to Orion and use the option shown below:
> <br>
> <br>
o All regular assignments are graded automatically by the Orion System.
o Each regular assignment must be completed by the due date.
o You may submit any regular assignment three times until the due date.
o The grade recorded is what you earn on your last attempt (which may or may not be your highest score).
o The grade on record at the due date is your grade.
o The "Requirements" option also shows the due dates for each assignment.
Submitting Regular Assignments
You will complete most of your regular assignments using a disk such as the one included with the text. To submit regular assignments use the "Requirements" option from your personal Orion System menu (see above).
> <br> Some of your assignments will be graded by an Excel document orion.xls. Some common questions about orion.xls are answered here.
> <br> Each assignment may be completed three times until the due date. Your last (most recent) score is what is counted for your course grade. The highest grade is not what is counted unless it is your last score.
> <br> If your score goes lower when you resubmit an assignment then the lower score is what counts toward your grade.
> <br> Some of your assignments will be graded by an Excel document orion.xls. Some common questions about orion.xls are answered here.
> <br> Each assignment may be completed three times until the due date. Your last (most recent) score is what is counted for your course grade. The highest grade is not what is counted unless it is your last score.
> <br> If your score goes lower when you resubmit an assignment then the lower score is what counts toward your grade.
Grade Status
Each time a regular assignment is graded a fresh copy of your grade status report will be put on the Internet for you to access. See this menu for access to status report.
> <br>
> <br>
Asking for Help
If you need assistance please ask the instructor. There is no value in holding back. If you ask for help do so before the due date for an assignment. The instructor will not answer email (or phone calls) about the homework on the due date.
6. Quizzes
o There are 5 objective quizzes (multiple choice, true-false, fill in the blank) through the semester. The schedule shows the due dates. The Requirements option (available from your Orion menu - see illustration below) gives you access to the quizzes.
> <br>
> <br>
o Each quiz score is computed as a percent correct. (a perfect score is 100% )
o Each quiz is worth 17 or 18 points toward your total semester grade. If you score 100% on a quiz then you earn all 17 or 18 points. If you score less than 100% the points earned are adjusted accordingly.
o Quizzes are not curved.
o Each quiz is administered during a "quiz period". Each quiz period is one week (five weekdays only).
o Each quiz contains material covered in class during the three weeks prior to the beginning of the quiz period.
o There is no final exam. The 5th quiz is also non-comprehensive and is taken during finals week.
o Quizzes are open notes and you are permitted to use other software while taking a quiz.
o You are not permitted to discuss anything with anyone while taking a quiz - violations are grounds for receiving a grade of 0 for the quiz in progress. This prohibition includes electronic communication of any sort.
o You may submit a quiz only one time.
Taking a Quiz
You may not begin any quiz until you demonstrate your understanding of the syllabus. You must do this by completing the Syllabus Contract.
> <br> Once you have successfully completed the Syllabus Contract you begin a quiz this way:
> <br> Once you have successfully completed the Syllabus Contract you begin a quiz this way:
10. Bring your student ID to the College of Business Computer Lab (2nd floor) during the quiz period. No quiz may be started less than X minutes before a proctor is due to leave the lab Where X is the length of the quiz - see the study guide. Each quiz is of different time length - it is your responsibility to check this.
11. Log on to Orion and select the "Requirements" option (see above).
12. Select the quiz you want to take.
13. READ EVERYTHING IN THE INSTRUCTIONS.
14. Open any programs you will need BEFORE you begin the quiz.
15. Read ALL dialog boxes.
16. Request that a proctor (look around the lab for one) check your id (name and picture). You may not begin a quiz without proper identification.
Study Tools
Study tools are available for each quiz. To view a study guide or try a practice quiz: Log on to Orion and select the "Study" option:
> <br>
> <br>
Viewing Results
Once a quiz period has ended you may view your quiz (all questions and answers) for up to seven days by locating the quiz in your status report.
Instructor Review of Your Quiz
You may request that your instructor review a quiz up to seven days after the end of the quiz period. Quizzes will not be examined after the seven days have elapsed.
Prerequisites
Several quizzes require that you successfully complete practice exercises first. You may attempt the exercises as often as you wish until you accomplish the required grade of 100. The specific quizzes requiring practice exercises are:
Quiz 1 requires a grade of at least:
100 in Data and Information Exercise 01
100 in Data and Information Exercise 02
100 in Data and Information Exercise 03
100 in Data and Information Exercise 04
100 in SQL Exercise 01
100 in SQL Exercise 02
100 in SQL Exercise 03
100 in Syllabus Contract
100 in Windows Exercise 01
100 in Windows Exercise 02
100 in Windows Exercise 03
Quiz 2 requires a grade of at least:
100 in Excel Exercise 01
100 in Excel Exercise 02
100 in Excel Exercise 03
100 in Syllabus Contract
Quiz 3 requires a grade of at least:
100 in Excel Exercise 04
100 in Excel Exercise 05
100 in Excel Exercise 06
100 in HTML Exercise 01
100 in HTML Exercise 02
100 in Syllabus Contract
Quiz 4 requires a grade of at least:
100 in Excel Exercise 07
100 in Excel Exercise 08
100 in Syllabus Contract
Quiz 5 requires a grade of at least:
100 in Database Exercise 01
100 in Syllabus Contract
7. Extra Credit
You may earn up to six extra-credit points during the course. Five points can be earned by answering extra credit questions (more about this below) and one point can be earned by answering two surveys.
How To Earn Extra Credit
0. Pop Extra Credit Questions - Up to Five Points
> <br> At various times when logged on to Orion you will be given the opportunity to answer questions about course content. The questions will most likely appear when you are not expecting them. Each question that you successfully answer will result in an award of 0.10 credit points. During the course you may earn up to five extra credit points this way.
> <br> The pop extra credit questions are all objective (multiple choice, true-false, fill in the blank). Upon answering a question you will learn immediately whether or not you received the credit. During the semester you will receive up to 50 extra credit pop questions each worth 0.10 points if you are correct in your answer.
> <br> Only points earned from correctly answering pop extra credit questions are available for Gift Catalog purchases (see below).
> <br> Everyone will get the same number of out of class opportunities. There will be additional opportunities available to those who attend class.
> <br> Tip: attending class and completing reading assignments on time will help you earn extra credit points.
> <br> At various times when logged on to Orion you will be given the opportunity to answer questions about course content. The questions will most likely appear when you are not expecting them. Each question that you successfully answer will result in an award of 0.10 credit points. During the course you may earn up to five extra credit points this way.
> <br> The pop extra credit questions are all objective (multiple choice, true-false, fill in the blank). Upon answering a question you will learn immediately whether or not you received the credit. During the semester you will receive up to 50 extra credit pop questions each worth 0.10 points if you are correct in your answer.
> <br> Only points earned from correctly answering pop extra credit questions are available for Gift Catalog purchases (see below).
> <br> Everyone will get the same number of out of class opportunities. There will be additional opportunities available to those who attend class.
> <br> Tip: attending class and completing reading assignments on time will help you earn extra credit points.
1. Surveys - Up to One Point
> <br> During the course two surveys are administered. Completion of each survey is worth 0.5 extra credit points for a total of one point if both surveys are completed.
> <br> During the course two surveys are administered. Completion of each survey is worth 0.5 extra credit points for a total of one point if both surveys are completed.
Grade Status
As extra credit is earned a fresh copy of your grade status report will be put on the Internet for you to access.
8. Gift Catalog
You may purchase gifts from the Gift catalog by using pop extra credit points that you earned. Click the "Tokens/Gifts" option to view the Gift Catalog.
> <br>
> <br> Gifts available include:
> <br>
> <br> Gifts available include:
o A due date extension
o An additional homework submission
o Erase a grade and start over
9. Rewind
You may complete overdue assignments late by using the "Rewind" option. Look for the movie projector on the course home page.
> <br>
> <br> When you use this option you will be assessed a late fee. This is different from the Gift Catalog because with rewind you do not spend extra-credit to begin a late course requirement but you are assessed a penalty for lateness.
> <br>
> <br> When you use this option you will be assessed a late fee. This is different from the Gift Catalog because with rewind you do not spend extra-credit to begin a late course requirement but you are assessed a penalty for lateness.
10. Early Bird Special
Get rewards for completing assignments early. Look for the Early Bird on your Orion menu for details.
> <br>
> <br>
11. Pay Per View
Use this option to view class lecture notes for classes that you miss or notes that you just want a second look at. In some cases there is a fee (pop extra credit points) to view lecture notes again.
> <br>
> <br> If you miss a class due to a legitimate absence the instructor will grant permission for you to view notes without charge. Contact the instructor.
> <br> Find this option on the Communication menu of Orion.
> <br>
> <br> If you miss a class due to a legitimate absence the instructor will grant permission for you to view notes without charge. Contact the instructor.
> <br> Find this option on the Communication menu of Orion.
12. Your Grade
Rules
o You semester grade is the weighted average of the 5 quizzes + 12 homework assignments.
o Each quiz and homework is to be completed on time by the due date. You receive no credit for quizzes or homeworks incomplete after the due date.
o Up to six points of extra credit may be added to your quiz and homework average.
o Nothing is curved: not homework assignments, not quizzes and not the semester final grades.
o This grading scale is used:
|
90+
|
80-89
|
70-79
|
60-69
|
0-59
|
|
A
|
B
|
C
|
D
|
F
|
o
> Grades are rounded, so 89.5 becomes an A. <div>
> No other excuses for lateness are accepted. If you miss a homework or quiz due date then you may purchase an extension from the gift catalog or use the rewind option if you wish to complete that assignment. Here are some excuses that are invalid and will be ignored: <div>
> Little tolerance is granted for email messages that violate these guidelines. In fact, if your e-mail is unacceptable you may receive no response! <br>
> If you miss class on days when attendance is taken you will not be given help by email for material covered on those days. Help will be provided (under those circumstances) during the instructor's office hours only. <br>
> The instructor will not answer email (or phone calls) about a homework assignment on the due date for that particular assignment. <div>
> <div>
> Grades are rounded, so 89.5 becomes an A. <div>
13. Daily Class Schedule and Reading Assignments
o The daily schedule indicates the topics covered during each class session.
o For sections that meet once a week the Tuesday and Thursday material are covered in one class meeting.
o You are expected to complete the reading assignments (pages shown in ()) prior to each class meeting.
o The Quiz column indicates what quiz covers the material shown to the left.
|
Week
|
Tuesday
|
Thursday
|
Quiz #
|
|
|
1
|
8/30 > Introduction <div> |
9/1
> Windows<br> (2.1-2.21) |
1
|
|
|
2
|
9/6
> Data and Information <br> (4.1-4.20) |
9/8
> Working with Data<br> (5.1-5.13) |
||
|
3
|
9/13
> Working with Data <br> (5.1-5.32) |
9/15 > Working with Data <div> |
||
|
|
Word is included on Quiz 1 - Read Chapter 3.
|
|
||
|
4
|
9/20
> Excel - Introduction: Functions & Formulas<br> (6.1-6.15) |
9/22 > Excel - Other Kinds of DataData Menu > (6.20-6.39)<div> |
2
|
|
|
5
|
9/27 > Excel<div> |
9/29
> Excel - Forms, Validation and Additional Analysis <br> (6.40-6.46) |
|
|
|
6
|
10/4 > Excel <div> |
10/6
> Information Systems <br> (8.1-8.8) |
|
|
|
|
Hardware/Software is included on Quiz 2 - Read Chapter 7.
|
|
||
|
7
|
10/11
> Excel - Cell Addressing <br> (6.51-6.62) |
10/13
> Excel - Logic<br> (6.67-6.80) |
3
|
|
|
8
|
10/18
> Excel - Logic<br> and Linking Spreadsheets (6.85) |
10/20 > GraphicsPowerPoint > (9.1-9.16 & Appendix A)<div> |
|
|
|
9
|
10/25
> HTML <br> (11.1-11.14) |
10/27 > HTML <div> |
|
|
|
|
Internet is included on Quiz 3 - Read Chapter 10.
|
|
||
|
10
|
11/1
> Excel - Merging Tables (6.86-6.91) & Relationship Between Records <br> (6.91-6.92) |
11/3
> Excel - Charts <br> (6.96-6.101) |
4
|
|
|
11
|
11/8
> Excel - Statistics <br> 6.102-6.106 |
11/10
> Societal Issues <br> (13.1-13.8) |
|
|
|
12
|
11/15
> Email & Communications <br> (12.22-12.24 & 12.1-12.22) |
11/17 > Communications <div> |
|
|
|
|
|
|
|
|
|
13
|
11/22
> Systems Analysis <br> (15.1-15.13) |
11/24 > Thanksgiving - No Class <div> |
5
|
|
|
14
|
11/29
> Database - Introduction, Single Table Operations <br> (14.1-14.15) |
12/1
> Database - Database Theory <br> (14.29-14.32) |
|
|
|
15
|
12/6 > Database <div> |
12/8
> Database - Creating a Database <br> (14.20 - 14.25) |
|
|
14. Tutors and Proctors
Lab tutors are available to help you during certain hours each week. They can be found in the College of Business Computer Lab on the building's 2nd floor.
> <br> The tutors are also proctors for your quizzes. Bring your ID to the lab to take a quiz. You must present yourself to a proctor to obtain permission to begin a quiz.
> <br> The proctor/tutor schedule:
> <br> To be announced.
> <br> You may not begin a quiz less than X minutes before the end of a quiz day Where "X" is the length of the quiz.
> <br> The tutors are also proctors for your quizzes. Bring your ID to the lab to take a quiz. You must present yourself to a proctor to obtain permission to begin a quiz.
> <br> The proctor/tutor schedule:
> <br> To be announced.
> <br> You may not begin a quiz less than X minutes before the end of a quiz day Where "X" is the length of the quiz.
15. Rules
In order to be fair to all students the following rules are enforced:
0. Review a Quiz Grade
You may ask the instructor to review any specific questions on any quiz or homework assignment. You must make the request not more than one week after the quiz or assignment due date has passed. Requests after that deadline will be automatically rejected.
1. Computer Virus
WARNING!!! If you submit an assignment with a computer virus then you fail the course. No exceptions! It is your responsibility to ensure that your work is clean.
2. Excused Absence and Lateness
The following are the Kent State accepted excuses for absence and late homework submission or permission to take a quiz late. No other excuses are accepted:
§ sickness with medical note
§ athletic event - with coach's note
§ religious observation
§ military responsibility with documentation
§ death in family with documentation
> No other excuses for lateness are accepted. If you miss a homework or quiz due date then you may purchase an extension from the gift catalog or use the rewind option if you wish to complete that assignment. Here are some excuses that are invalid and will be ignored: <div>
§ your Mom will call me to let me know why
§ your alarm didn't go off
§ your kids were sick
§ your parents needed your help
§ you had to work
§ you forgot the due date
§ you check your email, but you don't check Orion
§ you HAVE to get a good grade in here
§ your computer died
§ you went to a movie
§ you cannot access Orion
§ your diskette will not work
§ there was no lab assistant to proctor
§ the lab was in use by a class, etc.
§ your car quit
§ you had an accident
§ you had to watch a television show
§ you are lazy
§ you did not want to do the assignment
§ any new excuse we haven't heard which you come up with as your contribution to next semester's syllabus
3. Lecture
You are expected to respect the other students! This means never ridicule anyone for asking a question. There is no such thing as a stupid question but it is stupid not to ask questions! Laughing at or ridiculing another student is grounds for dismissal from this course with a grade of F.
4. Cheating
Cheating is grounds for automatic failure in the course so don't do it! Cheating includes, but is not limited to, copying from another student during an exam, submitting the same homework as another student, and illegally copying (really stealing) software. Any violation is grounds for dismissal from this course with a grade of F.
5. Respect
You are expected to act in a proper fashion at all times during the semester. Being respectful of other students and the instructor is essential. Behaving otherwise will not be tolerated and is grounds for dismissal from the course at any time during the semester. Dismissal results in a grade of F.
6. Cell Phones and Pagers
Use of a cell phone or pager during class is grounds for removal from the class. Use of such equipment is rude and disrespectful toward the instructor and other students (see respect above). Use of a cell phone or pager during class is grounds for dismissal from this course with a grade of F.
16. Etc.
0. Lecture
No early mass exodus from the lecture hall. If you plan to leave early then don't come to class. There are other students who want to be in class and it is not fair to disrupt them by the noise and disturbance of early departures.
1. Attendance
Attendance is not mandatory but it is strongly recommended. You are responsible for all material presented. It is not reasonable for you to ask for special consideration claiming that you miss material because you were not in class. On occasion attendance is taken during class. While you are not required to be present during class those who are may be eligible for special in-class awards and are eligible for help by email concerning material discussed that day in class.
> <br> Students absent are not eligible for in-class extra credit awards unless their absence is covered by one of the Kent State accepted excuses for absence (see list above). There are no exceptions.
> <br> Students absent are not eligible for in-class extra credit awards unless their absence is covered by one of the Kent State accepted excuses for absence (see list above). There are no exceptions.
2. In-Class Special Awards
In-class extra credit awards are given to students directly by the instructor. Only students present in class (see attendance above) are eligible for these awards. Any student claiming an award obtained from other than the instructor is dishonest and will be dealt with according to Kent State University regulations concerning student conduct.
3. Lateness to Class
You are not required to attend class. If you arrive late:
§ You may be denied permission to participate in In-Class Awards
§ You may be required to sit in the front row.
4. Students with Disabilities
In accordance with University policy, if you have a documented disability and require accommodations to obtain equal access in this course, please contact the instructor at the beginning of the semester or when given an assignment for which accommodation is required. Students with disabilities must verify their eligibility through the Office of Student Disability Services (SDS) in the Michael Schwartz Services Center (672-2972).
5. Thinking About a Major or Minor in IS?
Enrollment in the initial courses (24060 - Systems Analysis and 24070 Principles of System Development) requires permission. Click here for details.
6. e-mail
You are encouraged to communicate with your instructor using e-mail. There are some rules, however, that you must observe to use e-mail effectively:
1. Make sure that your spelling and grammar are correct.
2. Get to the point. Do not be long-winded. No jumbled verbiage.
3. Be organized. Be clear.
4. Be honest.
5. Use proper English - no slang.
6. DO NOT TYPE IN ALL CAPS!
7. Be respectful.
8. Say who you are.
> Little tolerance is granted for email messages that violate these guidelines. In fact, if your e-mail is unacceptable you may receive no response! <br>
> If you miss class on days when attendance is taken you will not be given help by email for material covered on those days. Help will be provided (under those circumstances) during the instructor's office hours only. <br>
> The instructor will not answer email (or phone calls) about a homework assignment on the due date for that particular assignment. <div>
17.
18. Syllabus Contract
This syllabus is a contract between you and the instructor. Your responsibilities are described in this document. Before you are permitted to attempt any of the course quizzes you must demonstrate that you understand the contract (syllabus) by earning a perfect score (100%) on a syllabus survey. Check the course schedule for the survey dates.
0. You are permitted to attempt the Syllabus Contract Survey as often as you like until you reach 100%.
1. You may attempt the Survey from any Internet connected computer using Internet Explorer.
2. It is strongly suggested that you print this syllabus (use the Print All option) and use it while completing the survey.
3. To find the Syllabus Contract select the Orion menu option indicated below:
> <div>
